var path = require('path')
daoModule = require('./DAO')
databaseModule = require(path.join(process.cwd(), 'modules/database'))

module.exports.clearGoodAttributes = function (goods_id, cb) {
  db = databaseModule.getDatabase()
  sql = 'DELETE FROM sp_goods_attr WHERE goods_id = ?'
  database.driver.execQuery(sql, [goods_id], function (err) {
    if (err) return cb('删除出错')
    cb(null)
  })
}

module.exports.list = function (goods_id, cb) {
  db = databaseModule.getDatabase()
  sql =
    'SELECT good_attr.goods_id,good_attr.attr_id,good_attr.attr_value,good_attr.add_price,attr.attr_name,attr.attr_sel,attr.attr_write,attr.attr_vals FROM sp_goods_attr as good_attr LEFT JOIN sp_attribute as attr ON attr.attr_id = good_attr.attr_id WHERE good_attr.goods_id = ?'
  database.driver.execQuery(sql, [goods_id], function (err, attrs) {
    if (err) return cb('删除出错')
    cb(null, attrs)
  })
}
